﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="FinInOutXsd" targetNamespace="http://tempuri.org/FinInOutXsd.xsd" xmlns:mstns="http://tempuri.org/FinInOutXsd.xsd" xmlns="http://tempuri.org/FinInOutXsd.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="JSHBIKEDBConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="JSHBIKEDBConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.WinForm.Properties.Settings.GlobalReference.Default.JSHBIKEDBConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="jsh_propertyTableAdapter" GeneratorDataComponentClassName="jsh_propertyTableAdapter" Name="jsh_property" UserDataComponentName="jsh_propertyTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="JSHBIKEDBConnectionString (Settings)" DbObjectName="JSHBIKEDB.dbo.jsh_property" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[jsh_property] WHERE (([id] = @Original_id) AND ((@IsNull_InCardCounts = 1 AND [InCardCounts] IS NULL) OR ([InCardCounts] = @Original_InCardCounts)) AND ((@IsNull_OutCardCounts = 1 AND [OutCardCounts] IS NULL) OR ([OutCardCounts] = @Original_OutCardCounts)) AND ((@IsNull_InitialCardCounts = 1 AND [InitialCardCounts] IS NULL) OR ([InitialCardCounts] = @Original_InitialCardCounts)) AND ((@IsNull_CurrentCardCounts = 1 AND [CurrentCardCounts] IS NULL) OR ([CurrentCardCounts] = @Original_CurrentCardCounts)) AND ((@IsNull_InMoney = 1 AND [InMoney] IS NULL) OR ([InMoney] = @Original_InMoney)) AND ((@IsNull_OutMoney = 1 AND [OutMoney] IS NULL) OR ([OutMoney] = @Original_OutMoney)) AND ((@IsNull_InitialMoney = 1 AND [InitialMoney] IS NULL) OR ([InitialMoney] = @Original_InitialMoney)) AND ((@IsNull_CurrentMoney = 1 AND [CurrentMoney] IS NULL) OR ([CurrentMoney] = @Original_CurrentMoney)) AND ((@IsNull_InReceiptMoney = 1 AND [InReceiptMoney] IS NULL) OR ([InReceiptMoney] = @Original_InReceiptMoney)) AND ((@IsNull_OutReceiptMoney = 1 AND [OutReceiptMoney] IS NULL) OR ([OutReceiptMoney] = @Original_OutReceiptMoney)) AND ((@IsNull_InitialReceiptMoney = 1 AND [InitialReceiptMoney] IS NULL) OR ([InitialReceiptMoney] = @Original_InitialReceiptMoney)) AND ((@IsNull_CurrentReceiptMoney = 1 AND [CurrentReceiptMoney] IS NULL) OR ([CurrentReceiptMoney] = @Original_CurrentReceiptMoney)) AND ((@IsNull_FixCards = 1 AND [FixCards] IS NULL) OR ([FixCards] = @Original_FixCards)) AND ((@IsNull_FixMoney = 1 AND [FixMoney] IS NULL) OR ([FixMoney] = @Original_FixMoney)) AND ((@IsNull_OperateAddress = 1 AND [OperateAddress] IS NULL) OR ([OperateAddress] = @Original_OperateAddress)) AND ((@IsNull_OperateAddressid = 1 AND [OperateAddressid] IS NULL) OR ([OperateAddressid] = @Original_OperateAddressid)) AND ((@IsNull_Operater = 1 AND [Operater] IS NULL) OR ([Operater] = @Original_Operater)) AND ((@IsNull_Operaterid = 1 AND [Operaterid] IS NULL) OR ([Operaterid] = @Original_Operaterid)) AND ((@IsNull_Operatetime = 1 AND [Operatetime] IS NULL) OR ([Operatetime] = @Original_Operatetime)) AND ((@IsNull_OperatePsamid = 1 AND [OperatePsamid] IS NULL) OR ([OperatePsamid] = @Original_OperatePsamid)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_InCardCounts" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InCardCounts" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_InCardCounts" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InCardCounts" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OutCardCounts" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OutCardCounts" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_OutCardCounts" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OutCardCounts" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_InitialCardCounts" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InitialCardCounts" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_InitialCardCounts" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InitialCardCounts" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CurrentCardCounts" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CurrentCardCounts" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CurrentCardCounts" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CurrentCardCounts" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_InMoney" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InMoney" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_InMoney" Precision="11" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="InMoney" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OutMoney" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OutMoney" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_OutMoney" Precision="11" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="OutMoney" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_InitialMoney" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InitialMoney" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_InitialMoney" Precision="11" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="InitialMoney" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CurrentMoney" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CurrentMoney" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_CurrentMoney" Precision="11" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CurrentMoney" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_InReceiptMoney" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InReceiptMoney" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_InReceiptMoney" Precision="11" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="InReceiptMoney" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OutReceiptMoney" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OutReceiptMoney" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_OutReceiptMoney" Precision="11" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="OutReceiptMoney" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_InitialReceiptMoney" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InitialReceiptMoney" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_InitialReceiptMoney" Precision="11" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="InitialReceiptMoney" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CurrentReceiptMoney" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CurrentReceiptMoney" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_CurrentReceiptMoney" Precision="11" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CurrentReceiptMoney" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FixCards" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FixCards" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FixCards" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FixCards" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FixMoney" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FixMoney" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_FixMoney" Precision="11" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="FixMoney" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OperateAddress" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OperateAddress" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_OperateAddress" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="OperateAddress" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OperateAddressid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OperateAddressid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_OperateAddressid" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="OperateAddressid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Operater" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Operater" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Operater" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Operater" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Operaterid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Operaterid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_Operaterid" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="Operaterid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Operatetime" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Operatetime" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Operatetime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Operatetime" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OperatePsamid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OperatePsamid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_OperatePsamid" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="OperatePsamid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[jsh_property] ([InCardCounts], [OutCardCounts], [InitialCardCounts], [CurrentCardCounts], [InMoney], [OutMoney], [InitialMoney], [CurrentMoney], [InReceiptMoney], [OutReceiptMoney], [InitialReceiptMoney], [CurrentReceiptMoney], [FixCards], [FixMoney], [OperateAddress], [OperateAddressid], [Operater], [Operaterid], [Operatetime], [OperatePsamid], [Describe]) VALUES (@InCardCounts, @OutCardCounts, @InitialCardCounts, @CurrentCardCounts, @InMoney, @OutMoney, @InitialMoney, @CurrentMoney, @InReceiptMoney, @OutReceiptMoney, @InitialReceiptMoney, @CurrentReceiptMoney, @FixCards, @FixMoney, @OperateAddress, @OperateAddressid, @Operater, @Operaterid, @Operatetime, @OperatePsamid, @Describe);
SELECT id, InCardCounts, OutCardCounts, InitialCardCounts, CurrentCardCounts, InMoney, OutMoney, InitialMoney, CurrentMoney, InReceiptMoney, OutReceiptMoney, InitialReceiptMoney, CurrentReceiptMoney, FixCards, FixMoney, OperateAddress, OperateAddressid, Operater, Operaterid, Operatetime, OperatePsamid, Describe FROM jsh_property WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@InCardCounts" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InCardCounts" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@OutCardCounts" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OutCardCounts" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@InitialCardCounts" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InitialCardCounts" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CurrentCardCounts" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CurrentCardCounts" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@InMoney" Precision="11" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="InMoney" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@OutMoney" Precision="11" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="OutMoney" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@InitialMoney" Precision="11" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="InitialMoney" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CurrentMoney" Precision="11" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CurrentMoney" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@InReceiptMoney" Precision="11" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="InReceiptMoney" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@OutReceiptMoney" Precision="11" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="OutReceiptMoney" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@InitialReceiptMoney" Precision="11" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="InitialReceiptMoney" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CurrentReceiptMoney" Precision="11" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CurrentReceiptMoney" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FixCards" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FixCards" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@FixMoney" Precision="11" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="FixMoney" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@OperateAddress" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="OperateAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@OperateAddressid" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="OperateAddressid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Operater" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Operater" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Operaterid" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="Operaterid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Operatetime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Operatetime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@OperatePsamid" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="OperatePsamid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Describe" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="Describe" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, InCardCounts, OutCardCounts, InitialCardCounts, CurrentCardCounts, InMoney, OutMoney, InitialMoney, CurrentMoney, InReceiptMoney, OutReceiptMoney, InitialReceiptMoney, CurrentReceiptMoney, FixCards, FixMoney, OperateAddress, OperateAddressid, Operater, Operaterid, Operatetime, OperatePsamid, Describe FROM dbo.jsh_property</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[jsh_property] SET [InCardCounts] = @InCardCounts, [OutCardCounts] = @OutCardCounts, [InitialCardCounts] = @InitialCardCounts, [CurrentCardCounts] = @CurrentCardCounts, [InMoney] = @InMoney, [OutMoney] = @OutMoney, [InitialMoney] = @InitialMoney, [CurrentMoney] = @CurrentMoney, [InReceiptMoney] = @InReceiptMoney, [OutReceiptMoney] = @OutReceiptMoney, [InitialReceiptMoney] = @InitialReceiptMoney, [CurrentReceiptMoney] = @CurrentReceiptMoney, [FixCards] = @FixCards, [FixMoney] = @FixMoney, [OperateAddress] = @OperateAddress, [OperateAddressid] = @OperateAddressid, [Operater] = @Operater, [Operaterid] = @Operaterid, [Operatetime] = @Operatetime, [OperatePsamid] = @OperatePsamid, [Describe] = @Describe WHERE (([id] = @Original_id) AND ((@IsNull_InCardCounts = 1 AND [InCardCounts] IS NULL) OR ([InCardCounts] = @Original_InCardCounts)) AND ((@IsNull_OutCardCounts = 1 AND [OutCardCounts] IS NULL) OR ([OutCardCounts] = @Original_OutCardCounts)) AND ((@IsNull_InitialCardCounts = 1 AND [InitialCardCounts] IS NULL) OR ([InitialCardCounts] = @Original_InitialCardCounts)) AND ((@IsNull_CurrentCardCounts = 1 AND [CurrentCardCounts] IS NULL) OR ([CurrentCardCounts] = @Original_CurrentCardCounts)) AND ((@IsNull_InMoney = 1 AND [InMoney] IS NULL) OR ([InMoney] = @Original_InMoney)) AND ((@IsNull_OutMoney = 1 AND [OutMoney] IS NULL) OR ([OutMoney] = @Original_OutMoney)) AND ((@IsNull_InitialMoney = 1 AND [InitialMoney] IS NULL) OR ([InitialMoney] = @Original_InitialMoney)) AND ((@IsNull_CurrentMoney = 1 AND [CurrentMoney] IS NULL) OR ([CurrentMoney] = @Original_CurrentMoney)) AND ((@IsNull_InReceiptMoney = 1 AND [InReceiptMoney] IS NULL) OR ([InReceiptMoney] = @Original_InReceiptMoney)) AND ((@IsNull_OutReceiptMoney = 1 AND [OutReceiptMoney] IS NULL) OR ([OutReceiptMoney] = @Original_OutReceiptMoney)) AND ((@IsNull_InitialReceiptMoney = 1 AND [InitialReceiptMoney] IS NULL) OR ([InitialReceiptMoney] = @Original_InitialReceiptMoney)) AND ((@IsNull_CurrentReceiptMoney = 1 AND [CurrentReceiptMoney] IS NULL) OR ([CurrentReceiptMoney] = @Original_CurrentReceiptMoney)) AND ((@IsNull_FixCards = 1 AND [FixCards] IS NULL) OR ([FixCards] = @Original_FixCards)) AND ((@IsNull_FixMoney = 1 AND [FixMoney] IS NULL) OR ([FixMoney] = @Original_FixMoney)) AND ((@IsNull_OperateAddress = 1 AND [OperateAddress] IS NULL) OR ([OperateAddress] = @Original_OperateAddress)) AND ((@IsNull_OperateAddressid = 1 AND [OperateAddressid] IS NULL) OR ([OperateAddressid] = @Original_OperateAddressid)) AND ((@IsNull_Operater = 1 AND [Operater] IS NULL) OR ([Operater] = @Original_Operater)) AND ((@IsNull_Operaterid = 1 AND [Operaterid] IS NULL) OR ([Operaterid] = @Original_Operaterid)) AND ((@IsNull_Operatetime = 1 AND [Operatetime] IS NULL) OR ([Operatetime] = @Original_Operatetime)) AND ((@IsNull_OperatePsamid = 1 AND [OperatePsamid] IS NULL) OR ([OperatePsamid] = @Original_OperatePsamid)));
SELECT id, InCardCounts, OutCardCounts, InitialCardCounts, CurrentCardCounts, InMoney, OutMoney, InitialMoney, CurrentMoney, InReceiptMoney, OutReceiptMoney, InitialReceiptMoney, CurrentReceiptMoney, FixCards, FixMoney, OperateAddress, OperateAddressid, Operater, Operaterid, Operatetime, OperatePsamid, Describe FROM jsh_property WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@InCardCounts" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InCardCounts" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@OutCardCounts" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OutCardCounts" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@InitialCardCounts" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InitialCardCounts" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CurrentCardCounts" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CurrentCardCounts" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@InMoney" Precision="11" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="InMoney" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@OutMoney" Precision="11" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="OutMoney" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@InitialMoney" Precision="11" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="InitialMoney" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CurrentMoney" Precision="11" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CurrentMoney" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@InReceiptMoney" Precision="11" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="InReceiptMoney" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@OutReceiptMoney" Precision="11" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="OutReceiptMoney" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@InitialReceiptMoney" Precision="11" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="InitialReceiptMoney" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CurrentReceiptMoney" Precision="11" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CurrentReceiptMoney" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FixCards" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FixCards" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@FixMoney" Precision="11" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="FixMoney" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@OperateAddress" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="OperateAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@OperateAddressid" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="OperateAddressid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Operater" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Operater" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Operaterid" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="Operaterid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Operatetime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Operatetime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@OperatePsamid" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="OperatePsamid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Describe" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="Describe" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_InCardCounts" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InCardCounts" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_InCardCounts" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InCardCounts" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OutCardCounts" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OutCardCounts" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_OutCardCounts" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OutCardCounts" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_InitialCardCounts" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InitialCardCounts" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_InitialCardCounts" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InitialCardCounts" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CurrentCardCounts" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CurrentCardCounts" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CurrentCardCounts" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CurrentCardCounts" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_InMoney" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InMoney" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_InMoney" Precision="11" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="InMoney" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OutMoney" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OutMoney" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_OutMoney" Precision="11" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="OutMoney" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_InitialMoney" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InitialMoney" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_InitialMoney" Precision="11" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="InitialMoney" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CurrentMoney" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CurrentMoney" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_CurrentMoney" Precision="11" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CurrentMoney" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_InReceiptMoney" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InReceiptMoney" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_InReceiptMoney" Precision="11" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="InReceiptMoney" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OutReceiptMoney" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OutReceiptMoney" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_OutReceiptMoney" Precision="11" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="OutReceiptMoney" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_InitialReceiptMoney" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InitialReceiptMoney" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_InitialReceiptMoney" Precision="11" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="InitialReceiptMoney" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CurrentReceiptMoney" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CurrentReceiptMoney" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_CurrentReceiptMoney" Precision="11" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CurrentReceiptMoney" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FixCards" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FixCards" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FixCards" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FixCards" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FixMoney" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FixMoney" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_FixMoney" Precision="11" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="FixMoney" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OperateAddress" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OperateAddress" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_OperateAddress" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="OperateAddress" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OperateAddressid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OperateAddressid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_OperateAddressid" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="OperateAddressid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Operater" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Operater" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Operater" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Operater" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Operaterid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Operaterid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_Operaterid" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="Operaterid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Operatetime" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Operatetime" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Operatetime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Operatetime" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OperatePsamid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OperatePsamid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_OperatePsamid" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="OperatePsamid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="InCardCounts" DataSetColumn="InCardCounts" />
              <Mapping SourceColumn="OutCardCounts" DataSetColumn="OutCardCounts" />
              <Mapping SourceColumn="InitialCardCounts" DataSetColumn="InitialCardCounts" />
              <Mapping SourceColumn="CurrentCardCounts" DataSetColumn="CurrentCardCounts" />
              <Mapping SourceColumn="InMoney" DataSetColumn="InMoney" />
              <Mapping SourceColumn="OutMoney" DataSetColumn="OutMoney" />
              <Mapping SourceColumn="InitialMoney" DataSetColumn="InitialMoney" />
              <Mapping SourceColumn="CurrentMoney" DataSetColumn="CurrentMoney" />
              <Mapping SourceColumn="InReceiptMoney" DataSetColumn="InReceiptMoney" />
              <Mapping SourceColumn="OutReceiptMoney" DataSetColumn="OutReceiptMoney" />
              <Mapping SourceColumn="InitialReceiptMoney" DataSetColumn="InitialReceiptMoney" />
              <Mapping SourceColumn="CurrentReceiptMoney" DataSetColumn="CurrentReceiptMoney" />
              <Mapping SourceColumn="FixCards" DataSetColumn="FixCards" />
              <Mapping SourceColumn="FixMoney" DataSetColumn="FixMoney" />
              <Mapping SourceColumn="OperateAddress" DataSetColumn="OperateAddress" />
              <Mapping SourceColumn="OperateAddressid" DataSetColumn="OperateAddressid" />
              <Mapping SourceColumn="Operater" DataSetColumn="Operater" />
              <Mapping SourceColumn="Operaterid" DataSetColumn="Operaterid" />
              <Mapping SourceColumn="Operatetime" DataSetColumn="Operatetime" />
              <Mapping SourceColumn="OperatePsamid" DataSetColumn="OperatePsamid" />
              <Mapping SourceColumn="Describe" DataSetColumn="Describe" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="FinInOutXsd" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="FinInOutXsd" msprop:Generator_UserDSName="FinInOutXsd">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="jsh_property" msprop:Generator_TableClassName="jsh_propertyDataTable" msprop:Generator_TableVarName="tablejsh_property" msprop:Generator_TablePropName="jsh_property" msprop:Generator_RowDeletingName="jsh_propertyRowDeleting" msprop:Generator_UserTableName="jsh_property" msprop:Generator_RowChangingName="jsh_propertyRowChanging" msprop:Generator_RowEvHandlerName="jsh_propertyRowChangeEventHandler" msprop:Generator_RowDeletedName="jsh_propertyRowDeleted" msprop:Generator_RowEvArgName="jsh_propertyRowChangeEvent" msprop:Generator_RowChangedName="jsh_propertyRowChanged" msprop:Generator_RowClassName="jsh_propertyRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="InCardCounts" msprop:Generator_ColumnVarNameInTable="columnInCardCounts" msprop:Generator_ColumnPropNameInRow="InCardCounts" msprop:Generator_ColumnPropNameInTable="InCardCountsColumn" msprop:Generator_UserColumnName="InCardCounts" type="xs:int" minOccurs="0" />
              <xs:element name="OutCardCounts" msprop:Generator_ColumnVarNameInTable="columnOutCardCounts" msprop:Generator_ColumnPropNameInRow="OutCardCounts" msprop:Generator_ColumnPropNameInTable="OutCardCountsColumn" msprop:Generator_UserColumnName="OutCardCounts" type="xs:int" minOccurs="0" />
              <xs:element name="InitialCardCounts" msprop:Generator_ColumnVarNameInTable="columnInitialCardCounts" msprop:Generator_ColumnPropNameInRow="InitialCardCounts" msprop:Generator_ColumnPropNameInTable="InitialCardCountsColumn" msprop:Generator_UserColumnName="InitialCardCounts" type="xs:int" minOccurs="0" />
              <xs:element name="CurrentCardCounts" msprop:Generator_ColumnVarNameInTable="columnCurrentCardCounts" msprop:Generator_ColumnPropNameInRow="CurrentCardCounts" msprop:Generator_ColumnPropNameInTable="CurrentCardCountsColumn" msprop:Generator_UserColumnName="CurrentCardCounts" type="xs:int" minOccurs="0" />
              <xs:element name="InMoney" msprop:Generator_ColumnVarNameInTable="columnInMoney" msprop:Generator_ColumnPropNameInRow="InMoney" msprop:Generator_ColumnPropNameInTable="InMoneyColumn" msprop:Generator_UserColumnName="InMoney" type="xs:decimal" minOccurs="0" />
              <xs:element name="OutMoney" msprop:Generator_ColumnVarNameInTable="columnOutMoney" msprop:Generator_ColumnPropNameInRow="OutMoney" msprop:Generator_ColumnPropNameInTable="OutMoneyColumn" msprop:Generator_UserColumnName="OutMoney" type="xs:decimal" minOccurs="0" />
              <xs:element name="InitialMoney" msprop:Generator_ColumnVarNameInTable="columnInitialMoney" msprop:Generator_ColumnPropNameInRow="InitialMoney" msprop:Generator_ColumnPropNameInTable="InitialMoneyColumn" msprop:Generator_UserColumnName="InitialMoney" type="xs:decimal" minOccurs="0" />
              <xs:element name="CurrentMoney" msprop:Generator_ColumnVarNameInTable="columnCurrentMoney" msprop:Generator_ColumnPropNameInRow="CurrentMoney" msprop:Generator_ColumnPropNameInTable="CurrentMoneyColumn" msprop:Generator_UserColumnName="CurrentMoney" type="xs:decimal" minOccurs="0" />
              <xs:element name="InReceiptMoney" msprop:Generator_ColumnVarNameInTable="columnInReceiptMoney" msprop:Generator_ColumnPropNameInRow="InReceiptMoney" msprop:Generator_ColumnPropNameInTable="InReceiptMoneyColumn" msprop:Generator_UserColumnName="InReceiptMoney" type="xs:decimal" minOccurs="0" />
              <xs:element name="OutReceiptMoney" msprop:Generator_ColumnVarNameInTable="columnOutReceiptMoney" msprop:Generator_ColumnPropNameInRow="OutReceiptMoney" msprop:Generator_ColumnPropNameInTable="OutReceiptMoneyColumn" msprop:Generator_UserColumnName="OutReceiptMoney" type="xs:decimal" minOccurs="0" />
              <xs:element name="InitialReceiptMoney" msprop:Generator_ColumnVarNameInTable="columnInitialReceiptMoney" msprop:Generator_ColumnPropNameInRow="InitialReceiptMoney" msprop:Generator_ColumnPropNameInTable="InitialReceiptMoneyColumn" msprop:Generator_UserColumnName="InitialReceiptMoney" type="xs:decimal" minOccurs="0" />
              <xs:element name="CurrentReceiptMoney" msprop:Generator_ColumnVarNameInTable="columnCurrentReceiptMoney" msprop:Generator_ColumnPropNameInRow="CurrentReceiptMoney" msprop:Generator_ColumnPropNameInTable="CurrentReceiptMoneyColumn" msprop:Generator_UserColumnName="CurrentReceiptMoney" type="xs:decimal" minOccurs="0" />
              <xs:element name="FixCards" msprop:Generator_ColumnVarNameInTable="columnFixCards" msprop:Generator_ColumnPropNameInRow="FixCards" msprop:Generator_ColumnPropNameInTable="FixCardsColumn" msprop:Generator_UserColumnName="FixCards" type="xs:int" minOccurs="0" />
              <xs:element name="FixMoney" msprop:Generator_ColumnVarNameInTable="columnFixMoney" msprop:Generator_ColumnPropNameInRow="FixMoney" msprop:Generator_ColumnPropNameInTable="FixMoneyColumn" msprop:Generator_UserColumnName="FixMoney" type="xs:decimal" minOccurs="0" />
              <xs:element name="OperateAddress" msprop:Generator_ColumnVarNameInTable="columnOperateAddress" msprop:Generator_ColumnPropNameInRow="OperateAddress" msprop:Generator_ColumnPropNameInTable="OperateAddressColumn" msprop:Generator_UserColumnName="OperateAddress" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="OperateAddressid" msprop:Generator_ColumnVarNameInTable="columnOperateAddressid" msprop:Generator_ColumnPropNameInRow="OperateAddressid" msprop:Generator_ColumnPropNameInTable="OperateAddressidColumn" msprop:Generator_UserColumnName="OperateAddressid" type="xs:long" minOccurs="0" />
              <xs:element name="Operater" msprop:Generator_ColumnVarNameInTable="columnOperater" msprop:Generator_ColumnPropNameInRow="Operater" msprop:Generator_ColumnPropNameInTable="OperaterColumn" msprop:Generator_UserColumnName="Operater" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Operaterid" msprop:Generator_ColumnVarNameInTable="columnOperaterid" msprop:Generator_ColumnPropNameInRow="Operaterid" msprop:Generator_ColumnPropNameInTable="OperateridColumn" msprop:Generator_UserColumnName="Operaterid" type="xs:long" minOccurs="0" />
              <xs:element name="Operatetime" msprop:Generator_ColumnVarNameInTable="columnOperatetime" msprop:Generator_ColumnPropNameInRow="Operatetime" msprop:Generator_ColumnPropNameInTable="OperatetimeColumn" msprop:Generator_UserColumnName="Operatetime" type="xs:dateTime" minOccurs="0" />
              <xs:element name="OperatePsamid" msprop:Generator_ColumnVarNameInTable="columnOperatePsamid" msprop:Generator_ColumnPropNameInRow="OperatePsamid" msprop:Generator_ColumnPropNameInTable="OperatePsamidColumn" msprop:Generator_UserColumnName="OperatePsamid" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Describe" msprop:Generator_ColumnVarNameInTable="columnDescribe" msprop:Generator_ColumnPropNameInRow="Describe" msprop:Generator_ColumnPropNameInTable="DescribeColumn" msprop:Generator_UserColumnName="Describe" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:jsh_property" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
  </xs:element>
</xs:schema>